package com.myworkbench.workbench.domain.entity.role;

public final  class RoleNamedSQL {

    public  final  static  String findAllRolesBy="SELECT \n" +
            "  _role.*\n" +
            "FROM\n" +
            "  role _role \n" +
            "WHERE " +
            "_role.is_delete= :isDelete and _role.id IN \n" +
            "  (\n" +
            "  SELECT \n" +
            "    rur.role_id \n" +
            "  FROM\n" +
            "  rel_user_role  rur \n" +
            "  WHERE  rur.user_id=:userId" +
            ")";

}
